<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="UserActivitiesDataSet" targetNamespace="http://tempuri.org/UserActivitiesDataSet.xsd" xmlns:mstns="http://tempuri.org/UserActivitiesDataSet.xsd" xmlns="http://tempuri.org/UserActivitiesDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="ApplicationGuidAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="ApprovalsConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="ApprovalsConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.ApprovalsConnectionString.ConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserActivitiesTableAdapter" Name="UserActivities">
            <MainSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="dbo.UserActivities" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [UserActivities] WHERE (([ActivityGuid] = @Original_ActivityGuid))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [UserActivities] ([ActivityGuid], [WorkflowGuid], [Description], [Complete], [ActivityTypeName], [RequiredRole]) VALUES (@ActivityGuid, @WorkflowGuid, @Description, @Complete, @ActivityTypeName, @RequiredRole);
SELECT ActivityGuid, WorkflowGuid, Description, Complete, ActivityTypeName, RequiredRole FROM UserActivities WHERE (ActivityGuid = @ActivityGuid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WorkflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkflowGuid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Complete" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Complete" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityTypeName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RequiredRole" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RequiredRole" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     UserActivities.*
FROM         UserActivities</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [UserActivities] SET [ActivityGuid] = @ActivityGuid, [WorkflowGuid] = @WorkflowGuid, [Description] = @Description, [Complete] = @Complete, [ActivityTypeName] = @ActivityTypeName, [RequiredRole] = @RequiredRole WHERE (([ActivityGuid] = @Original_ActivityGuid));
SELECT ActivityGuid, WorkflowGuid, Description, Complete, ActivityTypeName, RequiredRole FROM UserActivities WHERE (ActivityGuid = @ActivityGuid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WorkflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkflowGuid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Complete" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Complete" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ActivityTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ActivityTypeName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RequiredRole" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RequiredRole" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ActivityGuid" DataSetColumn="ActivityGuid" />
              <Mapping SourceColumn="WorkflowGuid" DataSetColumn="WorkflowGuid" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Complete" DataSetColumn="Complete" />
              <Mapping SourceColumn="ActivityTypeName" DataSetColumn="ActivityTypeName" />
              <Mapping SourceColumn="RequiredRole" DataSetColumn="RequiredRole" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="True" Modifier="Public" Name="CanUserWorkOnActivity" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     Count(ActivityGuid)
FROM         UserActivities
WHERE (ActivityGuid = @activityGuid) AND 
 (RequiredRole IN (SELECT RoleID FROM aspnet_UsersInRoles WHERE (UserId = @userGuid)))
</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="activityGuid" ColumnName="ActivityGuid" DataSourceName="[C:\WEB FORM WF APPROVALS STARTER KIT\APPROVALS\APP_DATA\ASPNETDB.MDF].dbo.UserActivities" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@activityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="userGuid" ColumnName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@userGuid" Precision="0" Scale="0" Size="16" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" Modifier="Public" Name="CompleteActivity" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>UPDATE [UserActivities] SET [Complete] = 1 WHERE ([ActivityGuid] = @activityGuid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="activityGuid" ColumnName="ActivityGuid" DataSourceName="[C:\WEB FORM WF APPROVALS STARTER KIT\APPROVALS\APP_DATA\ASPNETDB.MDF].dbo.UserActivities" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@activityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" Modifier="Public" Name="DeleteActivity" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>DELETE FROM [UserActivities] WHERE (([ActivityGuid] = @activityGuid))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="activityGuid" ColumnName="ActivityGuid" DataSourceName="[C:\WEB FORM WF APPROVALS STARTER KIT\APPROVALS\APP_DATA\ASPNETDB.MDF].dbo.UserActivities" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@activityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="dbo.UserActivities" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIncomplete" GenerateMethods="Both" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetDataByIncomplete" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     
     UserActivities.*
FROM         
     UserActivities
WHERE
     (WorkflowGuid = @workflowGuid) AND
     (Complete = 0)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="workflowGuid" ColumnName="WorkflowGuid" DataSourceName="[C:\WEB FORM WF APPROVALS STARTER KIT\APPROVALS\APP_DATA\ASPNETDB.MDF].dbo.UserActivities" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@workflowGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="WorkflowGuid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="dbo.UserActivities" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByUserGuid" GenerateMethods="Both" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetDataByUserGuid" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     UserActivities.*
FROM         UserActivities
WHERE (Complete &lt;&gt; 1) AND (
(RequiredRole IN (SELECT RoleID FROM aspnet_UsersInRoles WHERE (UserId = @userGuid))) OR
(ActivityGuid IN (SELECT ActivityGuid FROM UserActivityAssignments WHERE AssignedUser = @userGuid))
)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="userGuid" ColumnName="" DataSourceName="" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@userGuid" Precision="0" Scale="0" Size="16" SourceColumn="" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectType="Unknown" GenerateShortCommands="True" Modifier="Public" Name="IsActivityIncomplete" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT COUNT(*) FROM UserActivities WHERE (ActivityGuid = @activityGuid) AND (Complete &lt;&gt; 1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="activityGuid" ColumnName="ActivityGuid" DataSourceName="ASPNETDB.dbo.UserActivities" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@activityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" Modifier="Public" Name="SetRole" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>UPDATE [UserActivities] SET [RequiredRole] = @RequiredRole WHERE ([ActivityGuid] = @activityGuid);
DELETE FROM [UserActivityAssignments] WHERE ([ActivityGuid] = @activityGuid);</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="RequiredRole" ColumnName="RequiredRole" DataSourceName="[C:\WEB FORM WF APPROVALS STARTER KIT\APPROVALS\APP_DATA\ASPNETDB.MDF].dbo.UserActivities" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@RequiredRole" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="RequiredRole" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="activityGuid" ColumnName="ActivityGuid" DataSourceName="[C:\WEB FORM WF APPROVALS STARTER KIT\APPROVALS\APP_DATA\ASPNETDB.MDF].dbo.UserActivities" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@activityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserActivityAssignmentsTableAdapter" Name="UserActivityAssignments">
            <MainSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="dbo.UserActivityAssignments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [UserActivityAssignments] WHERE (([ActivityGuid] = @Original_ActivityGuid) AND ([AssignedUser] = @Original_AssignedUser) AND ([AssigningUser] = @Original_AssigningUser) AND ([DateAssigned] = @Original_DateAssigned))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_AssignedUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AssignedUser" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_AssigningUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AssigningUser" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateAssigned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateAssigned" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [UserActivityAssignments] ([ActivityGuid], [AssignedUser], [AssigningUser], [DateAssigned], [Notes]) VALUES (@ActivityGuid, @AssignedUser, @AssigningUser, @DateAssigned, @Notes);
SELECT ActivityGuid, AssignedUser, AssigningUser, DateAssigned, Notes FROM UserActivityAssignments WHERE (ActivityGuid = @ActivityGuid) AND (AssignedUser = @AssignedUser) AND (AssigningUser = @AssigningUser) AND (DateAssigned = @DateAssigned)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@AssignedUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AssignedUser" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@AssigningUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AssigningUser" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateAssigned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateAssigned" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Notes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     ActivityGuid, AssignedUser, AssigningUser, DateAssigned, Notes
FROM         UserActivityAssignments</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [UserActivityAssignments] SET [ActivityGuid] = @ActivityGuid, [AssignedUser] = @AssignedUser, [AssigningUser] = @AssigningUser, [DateAssigned] = @DateAssigned, [Notes] = @Notes WHERE (([ActivityGuid] = @Original_ActivityGuid) AND ([AssignedUser] = @Original_AssignedUser) AND ([AssigningUser] = @Original_AssigningUser) AND ([DateAssigned] = @Original_DateAssigned));
SELECT ActivityGuid, AssignedUser, AssigningUser, DateAssigned, Notes FROM UserActivityAssignments WHERE (ActivityGuid = @ActivityGuid) AND (AssignedUser = @AssignedUser) AND (AssigningUser = @AssigningUser) AND (DateAssigned = @DateAssigned)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@AssignedUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AssignedUser" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@AssigningUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AssigningUser" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateAssigned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateAssigned" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Notes" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Notes" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_AssignedUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AssignedUser" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_AssigningUser" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="AssigningUser" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateAssigned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateAssigned" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AssignedUser" DataSetColumn="AssignedUser" />
              <Mapping SourceColumn="AssigningUser" DataSetColumn="AssigningUser" />
              <Mapping SourceColumn="DateAssigned" DataSetColumn="DateAssigned" />
              <Mapping SourceColumn="Notes" DataSetColumn="Notes" />
              <Mapping SourceColumn="ActivityGuid" DataSetColumn="ActivityGuid" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="dbo.UserActivityAssignments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByActivityGuid" GenerateMethods="Both" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetDataByActivityGuid" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     ActivityGuid, AssignedUser, AssigningUser, DateAssigned, Notes
FROM         UserActivityAssignments
WHERE (ActivityGuid = @activityGuid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="activityGuid" ColumnName="ActivityGuid" DataSourceName="[C:\WEB FORM WF APPROVALS STARTER KIT\APPROVALS\APP_DATA\ASPNETDB.MDF].dbo.UserActivityAssignments" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@activityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="ActivityGuid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserActivityTypesTableAdapter" Name="UserActivityTypes">
            <MainSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="dbo.UserActivityTypes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[UserActivityTypes] WHERE (([Name] = @Original_Name))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[UserActivityTypes] ([Name]) VALUES (@Name);
SELECT Name FROM UserActivityTypes WHERE (Name = @Name)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Name FROM dbo.UserActivityTypes</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[UserActivityTypes] SET [Name] = @Name WHERE (([Name] = @Original_Name));
SELECT Name FROM UserActivityTypes WHERE (Name = @Name)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="aspnet_UsersTableAdapter" Name="aspnet_Users">
            <MainSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="dbo.aspnet_Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[aspnet_Users] WHERE (([ApplicationId] = @Original_ApplicationId) AND ([UserId] = @Original_UserId) AND ([UserName] = @Original_UserName) AND ([LoweredUserName] = @Original_LoweredUserName) AND ((@IsNull_MobileAlias = 1 AND [MobileAlias] IS NULL) OR ([MobileAlias] = @Original_MobileAlias)) AND ([IsAnonymous] = @Original_IsAnonymous) AND ([LastActivityDate] = @Original_LastActivityDate))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ApplicationId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ApplicationId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LoweredUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoweredUserName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MobileAlias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MobileAlias" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MobileAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MobileAlias" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsAnonymous" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsAnonymous" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastActivityDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastActivityDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [UserId], [UserName], [LoweredUserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (@ApplicationId, @UserId, @UserName, @LoweredUserName, @MobileAlias, @IsAnonymous, @LastActivityDate);
SELECT ApplicationId, UserId, UserName, LoweredUserName, MobileAlias, IsAnonymous, LastActivityDate FROM aspnet_Users WHERE (UserId = @UserId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ApplicationId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ApplicationId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LoweredUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoweredUserName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MobileAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MobileAlias" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsAnonymous" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsAnonymous" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastActivityDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastActivityDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT ApplicationId, UserId, UserName, LoweredUserName, MobileAlias, IsAnonymous, LastActivityDate FROM dbo.aspnet_Users</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[aspnet_Users] SET [ApplicationId] = @ApplicationId, [UserId] = @UserId, [UserName] = @UserName, [LoweredUserName] = @LoweredUserName, [MobileAlias] = @MobileAlias, [IsAnonymous] = @IsAnonymous, [LastActivityDate] = @LastActivityDate WHERE (([ApplicationId] = @Original_ApplicationId) AND ([UserId] = @Original_UserId) AND ([UserName] = @Original_UserName) AND ([LoweredUserName] = @Original_LoweredUserName) AND ((@IsNull_MobileAlias = 1 AND [MobileAlias] IS NULL) OR ([MobileAlias] = @Original_MobileAlias)) AND ([IsAnonymous] = @Original_IsAnonymous) AND ([LastActivityDate] = @Original_LastActivityDate));
SELECT ApplicationId, UserId, UserName, LoweredUserName, MobileAlias, IsAnonymous, LastActivityDate FROM aspnet_Users WHERE (UserId = @UserId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ApplicationId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ApplicationId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LoweredUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoweredUserName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MobileAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MobileAlias" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsAnonymous" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsAnonymous" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@LastActivityDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastActivityDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ApplicationId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ApplicationId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_UserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="UserName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LoweredUserName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoweredUserName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MobileAlias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MobileAlias" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MobileAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MobileAlias" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsAnonymous" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsAnonymous" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_LastActivityDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="LastActivityDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ApplicationId" DataSetColumn="ApplicationId" />
              <Mapping SourceColumn="UserId" DataSetColumn="UserId" />
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
              <Mapping SourceColumn="LoweredUserName" DataSetColumn="LoweredUserName" />
              <Mapping SourceColumn="MobileAlias" DataSetColumn="MobileAlias" />
              <Mapping SourceColumn="IsAnonymous" DataSetColumn="IsAnonymous" />
              <Mapping SourceColumn="LastActivityDate" DataSetColumn="LastActivityDate" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="aspnet_UsersInRolesTableAdapter" Name="aspnet_UsersInRoles">
            <MainSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="dbo.aspnet_UsersInRoles" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[aspnet_UsersInRoles] WHERE (([UserId] = @Original_UserId) AND ([RoleId] = @Original_RoleId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_RoleId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (@UserId, @RoleId);
SELECT UserId, RoleId FROM aspnet_UsersInRoles WHERE (RoleId = @RoleId) AND (UserId = @UserId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RoleId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT UserId, RoleId FROM dbo.aspnet_UsersInRoles</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[aspnet_UsersInRoles] SET [UserId] = @UserId, [RoleId] = @RoleId WHERE (([UserId] = @Original_UserId) AND ([RoleId] = @Original_RoleId));
SELECT UserId, RoleId FROM aspnet_UsersInRoles WHERE (RoleId = @RoleId) AND (UserId = @UserId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RoleId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_UserId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_RoleId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserId" DataSetColumn="UserId" />
              <Mapping SourceColumn="RoleId" DataSetColumn="RoleId" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="aspnet_RolesTableAdapter" Name="aspnet_Roles">
            <MainSource>
              <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="dbo.aspnet_Roles" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[aspnet_Roles] WHERE (([ApplicationId] = @Original_ApplicationId) AND ([LoweredRoleName] = @Original_LoweredRoleName))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ApplicationId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ApplicationId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LoweredRoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoweredRoleName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[aspnet_Roles] ([ApplicationId], [RoleId], [RoleName], [LoweredRoleName], [Description]) VALUES (@ApplicationId, @RoleId, @RoleName, @LoweredRoleName, @Description);
SELECT ApplicationId, RoleId, RoleName, LoweredRoleName, Description FROM aspnet_Roles WHERE (RoleId = @RoleId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ApplicationId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ApplicationId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RoleId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RoleName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LoweredRoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoweredRoleName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT ApplicationId, RoleId, RoleName, LoweredRoleName, Description FROM dbo.aspnet_Roles</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[aspnet_Roles] SET [ApplicationId] = @ApplicationId, [RoleId] = @RoleId, [RoleName] = @RoleName, [LoweredRoleName] = @LoweredRoleName, [Description] = @Description WHERE (([ApplicationId] = @Original_ApplicationId) AND ([LoweredRoleName] = @Original_LoweredRoleName));
SELECT ApplicationId, RoleId, RoleName, LoweredRoleName, Description FROM aspnet_Roles WHERE (RoleId = @RoleId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ApplicationId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ApplicationId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@RoleId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="RoleId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RoleName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LoweredRoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoweredRoleName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ApplicationId" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ApplicationId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LoweredRoleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoweredRoleName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ApplicationId" DataSetColumn="ApplicationId" />
              <Mapping SourceColumn="RoleId" DataSetColumn="RoleId" />
              <Mapping SourceColumn="RoleName" DataSetColumn="RoleName" />
              <Mapping SourceColumn="LoweredRoleName" DataSetColumn="LoweredRoleName" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="ApprovalsConnectionString (Web.config)" DbObjectName="dbo.aspnet_Applications" DbObjectType="Table" GenerateShortCommands="True" MethodsParameterType="CLR" Modifier="Public" Name="GetApplicationGuid" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="True">
                <CommandText>SELECT     ApplicationId
FROM         aspnet_Applications
WHERE     (ApplicationName = @applicationName)</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="False" AutogeneratedName="applicationName" ColumnName="ApplicationName" DataSourceName="[C:\WEB FORM WF APPROVALS STARTER KIT\APPROVALS\APP_DATA\APPROVALS.MDF].dbo.aspnet_Applications" DataTypeServer="nvarchar(256)" DbType="String" Direction="Input" ParameterName="@applicationName" Precision="0" ProviderType="NVarChar" Scale="0" Size="256" SourceColumn="ApplicationName" SourceColumnNullMapping="False" SourceVersion="Current">
                  </Parameter>
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="UserActivitiesDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="UserActivities">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ActivityGuid">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WorkflowGuid">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Complete" type="xs:boolean" />
              <xs:element name="ActivityTypeName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RequiredRole" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UserActivityAssignments">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AssignedUser" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" />
              <xs:element name="AssigningUser" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" />
              <xs:element name="DateAssigned" type="xs:dateTime" />
              <xs:element name="Notes" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ActivityGuid">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UserActivityTypes">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="aspnet_Users">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ApplicationId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" />
              <xs:element name="UserId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" />
              <xs:element name="UserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LoweredUserName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MobileAlias" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="16" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsAnonymous" type="xs:boolean" />
              <xs:element name="LastActivityDate" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="aspnet_UsersInRoles">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" />
              <xs:element name="RoleId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="aspnet_Roles">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ApplicationId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" />
              <xs:element name="RoleId" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" />
              <xs:element name="RoleName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LoweredRoleName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserActivities" />
      <xs:field xpath="mstns:ActivityGuid" />
    </xs:unique>
    <xs:unique name="UserActivityAssignments_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserActivityAssignments" />
      <xs:field xpath="mstns:ActivityGuid" />
      <xs:field xpath="mstns:AssignedUser" />
      <xs:field xpath="mstns:AssigningUser" />
      <xs:field xpath="mstns:DateAssigned" />
    </xs:unique>
    <xs:unique name="UserActivityTypes_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserActivityTypes" />
      <xs:field xpath="mstns:Name" />
    </xs:unique>
    <xs:unique name="aspnet_Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:aspnet_Users" />
      <xs:field xpath="mstns:ApplicationId" />
      <xs:field xpath="mstns:LoweredUserName" />
    </xs:unique>
    <xs:unique name="aspnet_UsersInRoles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:aspnet_UsersInRoles" />
      <xs:field xpath="mstns:UserId" />
      <xs:field xpath="mstns:RoleId" />
    </xs:unique>
    <xs:unique name="aspnet_Roles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:aspnet_Roles" />
      <xs:field xpath="mstns:ApplicationId" />
      <xs:field xpath="mstns:LoweredRoleName" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_UserActivities_aspnet_Roles" msdata:parent="aspnet_Roles" msdata:child="UserActivities" msdata:parentkey="RoleId" msdata:childkey="RequiredRole" />
      <msdata:Relationship name="FK_UserActivities_UserActivityTypes" msdata:parent="UserActivityTypes" msdata:child="UserActivities" msdata:parentkey="Name" msdata:childkey="ActivityTypeName" />
      <msdata:Relationship name="FK_UserActivityAssignments_Assigned_aspnet_Users" msdata:parent="aspnet_Users" msdata:child="UserActivityAssignments" msdata:parentkey="UserId" msdata:childkey="AssignedUser" />
      <msdata:Relationship name="FK_UserActivityAssignments_Assigning_aspnet_Users" msdata:parent="aspnet_Users" msdata:child="UserActivityAssignments" msdata:parentkey="UserId" msdata:childkey="AssigningUser" />
      <msdata:Relationship name="FK__aspnet_Us__RoleI__398D8EEE" msdata:parent="aspnet_Roles" msdata:child="aspnet_UsersInRoles" msdata:parentkey="RoleId" msdata:childkey="RoleId" />
      <msdata:Relationship name="FK__aspnet_Us__UserI__38996AB5" msdata:parent="aspnet_Users" msdata:child="aspnet_UsersInRoles" msdata:parentkey="UserId" msdata:childkey="UserId" />
      <msdata:Relationship name="FK_UserActivityAssignments_UserActivities" msdata:parent="UserActivities" msdata:child="UserActivityAssignments" msdata:parentkey="ActivityGuid" msdata:childkey="ActivityGuid" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>